﻿
CREATE PROCEDURE [dbo].[ServiceApplications]

AS
BEGIN
	SELECT ServiceApplication.DisplayName,  ServiceApplication.Status, Service.TypeName
	from ServiceApplication, Service
	Where service.ServiceID = ServiceApplication.ServiceID
END